<?php
require_once('configure.php'); 
$query = "
	SELECT b.nama,a.nik,a.karyawan_id FROM  karyawan a
	INNER JOIN biodata b ON a.biodata_id = b.biodata_id
	WHERE  b.nama LIKE '{$_GET['q']}%'     
";
 
$res = my_query($query);
 
while( $rw=my_fetch_array($res) ){
	if(is_calon($rw['karyawan_id']))
	echo strtoupper($rw['nama'])."|".$rw['nik']."\n";
}
exit;
?>